Monitoring the task and database: Oracle

This section discusses how to monitor the task and database for Oracle. For information on how to monitor the task and database for SQL Server, see Monitoring the task and database: SQL Server.

The status and results of an IEE Active Storage Manager task can be monitored using the IEE Task Monitor.

Right-click on any task and choose Task Logs for more information.

If any of the task template parameters are invalid, the task log will contain messages indicating the error. For example:

If the target tablespace for any subpartition to be moved does not exist, the task log will contain messages indicating the error. For example:

If this occurs, consider using the Identify tier 2 (and tier 3, if configured) tablespaces step of the installation process to generate the necessary CREATE TABLESPACE commands for the missing tablespaces.

If any subpartitions were not able to be moved because of missing tablespaces, the task will result in an error status. For example:

For each subpartition moved, a message will appear in the task log. For example:

Once all the subpartitions eligible to be moved have been processed, IEE Active Storage Manager identifies any tablespaces that are now empty as a result of moving subpartitions. For each of these tablespaces, the task log contains a message including a prototype DROP TABLESPACE command. If desired, a DBA can copy the entire block of messages and paste them into a text editor to be prepared for running against the database. For example: